UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6DdvAT9GPJUqkq0ra2A0lHZaIOibGNr5ixU2yjAa1mg='
WHERE
key_id = '550cd25ec3c506e9690e7941155cfd9581a33a81a7a452a11f19260dc8997e9d'
AND (
token = '6DdvAT9GPJUqkq0ra2A0lHZaIOibGNr5ixU2yjAa1mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)