UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZcM3UzK2h+0iusM+E5uyiqEZsfXaBGQhkua9OiNUWnA='
WHERE
key_id = 'ee44f97d3c852db479a749a54a86d9c6ef8e798b1f93be748828bd82138a608b'
AND (
token = 'ZcM3UzK2h+0iusM+E5uyiqEZsfXaBGQhkua9OiNUWnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)