UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rvVMrpB7tN3n86zjjwImkfypQRo1fIRxlzmHoFJUIRs='
WHERE
key_id = '651d24bfea991caf0ab988bdd0d395be87f0d36c661497b59bd6b9181070f4e1'
AND (
token = 'rvVMrpB7tN3n86zjjwImkfypQRo1fIRxlzmHoFJUIRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)