UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RX+/Yrop3a2u5uRsYZ58H02sPZwrsygIFZ8aardEpGU='
WHERE
key_id = '1c29eff146ef0bfa1fa4b8c10ff4114b4515f833294a44aae24e6f0ca1952916'
AND (
token = 'RX+/Yrop3a2u5uRsYZ58H02sPZwrsygIFZ8aardEpGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)