UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nH5suSBhZzgECgRkCDrwch2CQDdUP9TP1hv5cNGonb8='
WHERE
key_id = '39db1722659cce1b3b7a573242176a19be786bc94bcc9b9ba6af75caff99e555'
AND (
token = 'nH5suSBhZzgECgRkCDrwch2CQDdUP9TP1hv5cNGonb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)