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