UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NNXrg8DzGvobhWHu82MmwlsxPM7/IaHvP9qcKFkHhMs='
WHERE
key_id = 'b3b2394677f133009250cc5f306767c2a8c0dee29cee578c94e1e7be6fc4a65e'
AND (
token = 'NNXrg8DzGvobhWHu82MmwlsxPM7/IaHvP9qcKFkHhMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)