UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n/PhGJgBnsHTKoSwlMFFd5wthliH6C0wtkenbKLEM2g='
WHERE
key_id = 'a586a46d3f7df3f8c2fd4b621e623580208175623f5c0681a059a9a05a4a3af4'
AND (
token = 'n/PhGJgBnsHTKoSwlMFFd5wthliH6C0wtkenbKLEM2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)