UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o9yvWLU5ZMkVSPINoJLKal3DNSUHoMWeIbwZ1g9ku2Q='
WHERE
key_id = '1cacd25dc9413e0a8d785d48ff678ec7854d88d3fd21aef5689d170b6be8f795'
AND (
token = 'o9yvWLU5ZMkVSPINoJLKal3DNSUHoMWeIbwZ1g9ku2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)