UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1W8gCQWWkFHKCnn4N4zHFXPpk62lsnaA0lhCdDjRiSE='
WHERE
key_id = '1654718360e3eaf2a02ffa6e3198ec4dd85fd6ccf4f10d08b915b41dff12faa0'
AND (
token = '1W8gCQWWkFHKCnn4N4zHFXPpk62lsnaA0lhCdDjRiSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)