UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PiSR0K8mHv6ZeZiHdbskcnMER5eynn7y3oelCcOYZA='
WHERE
key_id = '053e3d7cf05669d7186a9e7528c2bb9b29ade1ab745278eaaa6d6de1e527bd17'
AND (
token = '1PiSR0K8mHv6ZeZiHdbskcnMER5eynn7y3oelCcOYZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)