UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WQAOywLlkuNhUvO9lGkHJ3SWJOi1EBQmXeCvyA8on2c='
WHERE
key_id = 'fcac7a62404738cb0da3a4be8f598537e2f20b73e4e0a683ceb29ad8cd5b1f5a'
AND (
token = 'WQAOywLlkuNhUvO9lGkHJ3SWJOi1EBQmXeCvyA8on2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)