UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0RBRKU5+ci7iF/rTLNF3kdGJVy87WZJ0NoExDf9QNuc='
WHERE
key_id = 'be08694c0fd63341482ec6eaaf0b9839c586128d174c681d8f208c4c9c4568f6'
AND (
token = '0RBRKU5+ci7iF/rTLNF3kdGJVy87WZJ0NoExDf9QNuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)