UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6K5DBfAPKkyhFLg3ZdOn0iF1zqDClo9sdoTeXWcbHMM='
WHERE
key_id = 'ca16e010ec997c6b943df444c900b21a4335ea6bf43a39f790341f2182704fde'
AND (
token = '6K5DBfAPKkyhFLg3ZdOn0iF1zqDClo9sdoTeXWcbHMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)