UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RDNZPDMKlJ5Cck3KFSS0fI4vKCDLE9YeVwT8p/41M0M='
WHERE
key_id = '9d927d63e80cdf29e089f6cd70d82386cf8acd2c40b874788c859f36ee99d136'
AND (
token = 'RDNZPDMKlJ5Cck3KFSS0fI4vKCDLE9YeVwT8p/41M0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)