UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+x4eahsZ1rroGEKEMLKjBLiyU6/uG1rfr0ExwyQTXI='
WHERE
key_id = 'e0743c70fa7a0ad0b1164511793e51500a7458ac56b5dcae6798ac918120fe85'
AND (
token = 'z+x4eahsZ1rroGEKEMLKjBLiyU6/uG1rfr0ExwyQTXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)