UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yP5FCbr2V4EiZRq0Je0b7TbO8hT/zrrFSUF8wqkOxfc='
WHERE
key_id = 'b996c9de6bd0ed524b58311b0dfc2c90880bcd056e0155c51694b888758ba6b4'
AND (
token = 'yP5FCbr2V4EiZRq0Je0b7TbO8hT/zrrFSUF8wqkOxfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)