UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8HUsuVJpaUxPOqSnZsPxBqII4l5yfHPVXeHYivmYbaU='
WHERE
key_id = '3ab17e7ce3a4bfaf70a3c10981da8ce90957bea42701e3cabf95eb0145077655'
AND (
token = '8HUsuVJpaUxPOqSnZsPxBqII4l5yfHPVXeHYivmYbaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)