UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K9R6KZ6opDO1KMiBds/nm5VkJomLd+xBm+OBXOoCKE0='
WHERE
key_id = 'bc198c0263304cd1d6820b687e444d20697c31d0af0290d6f8f4407b581ed615'
AND (
token = 'K9R6KZ6opDO1KMiBds/nm5VkJomLd+xBm+OBXOoCKE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)