UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Xakvjg14DhRFdnwuKHPYBJxbTA5A0wAsrTB/PniWuU='
WHERE
key_id = '14af603a9cb275bfce0a44d8b81ebd02a83e9a10198f76136c59a776882a2d8a'
AND (
token = '+Xakvjg14DhRFdnwuKHPYBJxbTA5A0wAsrTB/PniWuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)