UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B4mW/3eEwzPq2nQOewX6v4nvYt5fIDhkEDRa5SQ66Ak='
WHERE
key_id = 'a5fe93585d674292076fa8fe7378892b7e92decd7e86412deaabf79189b503df'
AND (
token = 'B4mW/3eEwzPq2nQOewX6v4nvYt5fIDhkEDRa5SQ66Ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)