UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcWG2GkhlnqCGiE2RVgRN34o6ZaObKAwY7CNXV5aztY='
WHERE
key_id = '71b06c29f00997b81f5335e79b703e7340a7e7e1bcf4f77701b0fe7dff5f2018'
AND (
token = 'XcWG2GkhlnqCGiE2RVgRN34o6ZaObKAwY7CNXV5aztY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)