UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yqH98hPRFO+TokqhqjhkPwLk6X8Lss4+xwZOD5X5ccs='
WHERE
key_id = 'c6fd3930f5d5146ce4b8bcfb929221048dc9d12237c6dd88ffe0547b37d8ab9e'
AND (
token = 'yqH98hPRFO+TokqhqjhkPwLk6X8Lss4+xwZOD5X5ccs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)