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