UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCWhIQDr4OaNlcGvjT2cHr/I+KznxG8oE2w2MvLhNwU='
WHERE
key_id = '0b681ecabb8ed843af63d6c0676e38fceb33d09f5d239fdbc624bf3cc2fe895f'
AND (
token = 'lCWhIQDr4OaNlcGvjT2cHr/I+KznxG8oE2w2MvLhNwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)