UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Vp4C0NYW1QvFA4Ozje4UJJzl6AciHV1UYOtE09ii40='
WHERE
key_id = '31c5bd27b03871601a6df898fd01bd2d46aca89d3eef1bf976def30f6b4d0fe0'
AND (
token = '9Vp4C0NYW1QvFA4Ozje4UJJzl6AciHV1UYOtE09ii40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)