UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cfPUu7dl6Xb6owZqOjoGrM6+xkyt05ji0OvaJwH5yn8='
WHERE
key_id = 'ee64f54649409845d83295f09bad1f289783a46b5578031a416c500473367ec5'
AND (
token = 'cfPUu7dl6Xb6owZqOjoGrM6+xkyt05ji0OvaJwH5yn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)