UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aTpW5HO9Arvpbaiz/94Cy3WGEABuzv19MMvA5oOxaKU='
WHERE
key_id = 'c3280ff1faf49733c177fbda27923d72b1a8e902a35f92fc4fe00255b23106d0'
AND (
token = 'aTpW5HO9Arvpbaiz/94Cy3WGEABuzv19MMvA5oOxaKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)