UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dHVeS43hoRpzxdN6onPKGTJNLtVAEfoVSZCWfS/twhY='
WHERE
key_id = 'f871bea4a0577019f8f0560d320e3f9996d2dadabb88e4a1f098f9615a1eb585'
AND (
token = 'dHVeS43hoRpzxdN6onPKGTJNLtVAEfoVSZCWfS/twhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)