UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hYBlOxJVQ58Pdwz4zvRuc5zEzdWqvIvpa+8gnLn6enA='
WHERE
key_id = 'a7c8a9deaae08ce941f3cbab1d670a5e7c2789fd088d843f31a19aa63c3ecd02'
AND (
token = 'hYBlOxJVQ58Pdwz4zvRuc5zEzdWqvIvpa+8gnLn6enA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)