UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RQ8aJcj0GRAvmy0cbChVCGW/94NqJU04Vmf3WmPZxlQ='
WHERE
key_id = 'd34d3794c47680ef8f9b62809b3683e3d837ce5330c95cc8181af9ce64a135a7'
AND (
token = 'RQ8aJcj0GRAvmy0cbChVCGW/94NqJU04Vmf3WmPZxlQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)