UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I6unAzprvGJO3aXYsbclxO3/WY4x46zbqU3p5RUd324='
WHERE
key_id = 'ba1308d4262d8b9e83dd0a8b0e50f34272aca2a5fb477912438e0a1057de90cc'
AND (
token = 'I6unAzprvGJO3aXYsbclxO3/WY4x46zbqU3p5RUd324='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)