UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AWmYljtab7qLMuE1FBgV3/u1wrwkcDKruf5hb9dbsYE='
WHERE
key_id = '0ba472e49a1eb31f1b752b265dab03388df78068060db8caef1ff8e334c13e3f'
AND (
token = 'AWmYljtab7qLMuE1FBgV3/u1wrwkcDKruf5hb9dbsYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)