UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LiTKMvBzZsIFCS7fzsg9thGylH0hm6SIM+/XCVLCfVM='
WHERE
key_id = '507d460ad5c68abf6916f99470eff09b7ed2dfffa72f7f4c20887246fe90fec3'
AND (
token = 'LiTKMvBzZsIFCS7fzsg9thGylH0hm6SIM+/XCVLCfVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)