UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wo6pON/1yIHJj2h/pdOUiK4IFFvpWEKN6lSvc/eev7o='
WHERE
key_id = '24939e1ca4b08dcd0691960d3161b37507a3089eea2d118682bcfb45d7a262ed'
AND (
token = 'wo6pON/1yIHJj2h/pdOUiK4IFFvpWEKN6lSvc/eev7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)