UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fMHUMf5FO/061m54JkAP6tiBJaqSkQGuLjZEv4y6rx4='
WHERE
key_id = 'dd4d4f0180fecd0560888ab695f6b07b9547ea675f20dd46bf964ba2c15a9cd5'
AND (
token = 'fMHUMf5FO/061m54JkAP6tiBJaqSkQGuLjZEv4y6rx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)