UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnHBZRGEW6XfXN3EKp8O1Okjudriy4VV3MSrkwPmf9Q='
WHERE
key_id = '0efd32ca5149ad58fb07b6a17af338a4e7e05edd3c14053a4e5e3a2ff04e3467'
AND (
token = 'KnHBZRGEW6XfXN3EKp8O1Okjudriy4VV3MSrkwPmf9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)