UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/y8AVdYEOOqEPToBVKOvubMAmyBNbTaIiwaPkUYSeSo='
WHERE
key_id = '57b9ce806892c5cbb769af7f2cabfe63ffc3cd57b65e9ebd3951fe43e0a1058d'
AND (
token = '/y8AVdYEOOqEPToBVKOvubMAmyBNbTaIiwaPkUYSeSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)