UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LcDW/I8iefmg963c025P+Alf4F25M18zbw9YZMsDkU='
WHERE
key_id = '349f4709cec95978d2d9d16ee1cfcb9525dd2af8fecbe45a9b3dbd74fe5c2bf0'
AND (
token = '6LcDW/I8iefmg963c025P+Alf4F25M18zbw9YZMsDkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)