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