UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gLamHd7KQMqTpN+aZB2oXmZTy7PC+x6LiM8Ik8dh1f0='
WHERE
key_id = 'c9b98174de9304a9b58fb93bddcdd0854527a1dea422cefe0426099baa8bc25e'
AND (
token = 'gLamHd7KQMqTpN+aZB2oXmZTy7PC+x6LiM8Ik8dh1f0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)