UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0AqlVVbEVvHQJgUAVL+Gk+5yG5YsOWKa9G2rRTuOSQ='
WHERE
key_id = '8fc614f3463497541ec22733a05e66f970f2e6341f255b2110247e062f8e392b'
AND (
token = 'q0AqlVVbEVvHQJgUAVL+Gk+5yG5YsOWKa9G2rRTuOSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)