UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hFY38rpda1UY9Glxgy33YWKtWGMD9bFuR2OwopY5lSU='
WHERE
key_id = '97d20e42022c13a39f213606c8da3845edca221b564dc63944411384dbf9bfb9'
AND (
token = 'hFY38rpda1UY9Glxgy33YWKtWGMD9bFuR2OwopY5lSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)