UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C3KjIkhclKMgFDUUWnlJwhwIT1wwAblHtV463FJOt8Y='
WHERE
key_id = 'd5c1d76a5cd3696cf5e2865652466a78e5c699146c10de225dfb58e9f915a167'
AND (
token = 'C3KjIkhclKMgFDUUWnlJwhwIT1wwAblHtV463FJOt8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)