UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kC94ETszJemO+J9flC8JGJO171vbeC6KoT/gcN9BK1s='
WHERE
key_id = 'eb47ed9ed469c84887cb70b96f3eab8c9722fd48808a6e7b0d276044e2fe9dfe'
AND (
token = 'kC94ETszJemO+J9flC8JGJO171vbeC6KoT/gcN9BK1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)