UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GgyQCzSBwJF8CmycB/HGMTKGTPvGBheA3wqvJH2rrw='
WHERE
key_id = '565162d583b48879baacf95dfcae6a7216c5094d7412c782896ab3eaa782a994'
AND (
token = '7GgyQCzSBwJF8CmycB/HGMTKGTPvGBheA3wqvJH2rrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)