UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N/7OXQuDY/F/z3QiTt3oeHS5Zx4rUkdbyhw4RpNmjx0='
WHERE
key_id = 'ef1252e6d417ea098d8ed47d4af6f7be9af49026340e9bcd005f3f4bd305ecee'
AND (
token = 'N/7OXQuDY/F/z3QiTt3oeHS5Zx4rUkdbyhw4RpNmjx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)