UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6RVVGgQqZdO186x+z9qcvIoW3zGFWaabMSiFI8KxD4o='
WHERE
key_id = '4f8b38000fd88fec914e20a73dafba349774b960d9f7c502852202b140069936'
AND (
token = '6RVVGgQqZdO186x+z9qcvIoW3zGFWaabMSiFI8KxD4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)