UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YWFLlp8zLLkIiW1161X2X+t9VK33dKKmgXkJJBLUHs='
WHERE
key_id = '45167ea2c9a24e7e13b6d09a4be2ff93ad687cec4b19750f531d51c99643c794'
AND (
token = '3YWFLlp8zLLkIiW1161X2X+t9VK33dKKmgXkJJBLUHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)