UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KaLL/NpL+rgI+o8DB1Tqbdpl/0ZYkYEJxM/SZplDdVQ='
WHERE
key_id = '946a4bdc9551cc667aaa747124b39d71abc1fa1410a97b1898cbaee167ebc27a'
AND (
token = 'KaLL/NpL+rgI+o8DB1Tqbdpl/0ZYkYEJxM/SZplDdVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)