UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfDG9XhX2VZLyWMspGjT0M7AfacD3kwdq8TYTdmKkmo='
WHERE
key_id = '9bdfa24ce5c6b5cfc216b6d6ed66392e4f24a7ab60029eaf8d4e2cf45ca18722'
AND (
token = 'ZfDG9XhX2VZLyWMspGjT0M7AfacD3kwdq8TYTdmKkmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)