UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sk48KcXg1muSXBS8QMYkG7XsmaGSkPSCvX1uTF85dTU='
WHERE
key_id = 'ba5420f7250951470cce9155def95638423249c9830882092467c362ce48b1c4'
AND (
token = 'Sk48KcXg1muSXBS8QMYkG7XsmaGSkPSCvX1uTF85dTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)