UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vw30gVyvQVuK/14hRmlgS6/LExei3F5rAsSMN31fens='
WHERE
key_id = 'e1d551cadeaa51a1cc5aea340f4df6dfcaaf8a48f102b6dd361c54084c87d7e6'
AND (
token = 'vw30gVyvQVuK/14hRmlgS6/LExei3F5rAsSMN31fens='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)