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