UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZY8E6usrR2oVnuRLr7IRMbP9NF+z6SYPALCpHGw+yT0='
WHERE
key_id = '2ae46dd7b0bc4e2b0c063c5edaa841e0302e435be30d01a7f5ae04e04b6ea12b'
AND (
token = 'ZY8E6usrR2oVnuRLr7IRMbP9NF+z6SYPALCpHGw+yT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)