UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlmrMbAshyY//r+244jkQUG5xoXO0g53JFB/vsqqNsA='
WHERE
key_id = '3220a65495952a2ddf93a936dc87f36bb8d610b57ce31095ac059c87829a30fd'
AND (
token = 'ZlmrMbAshyY//r+244jkQUG5xoXO0g53JFB/vsqqNsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)