UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uTnkYZ53xPCis20ZbkZ7Dgjw80bOx0wkXQgfYHmIZKk='
WHERE
key_id = '1d0f73284580d1de4edac926e0e4abbc24cf66b0bd49bff0c7caba397b7c4f54'
AND (
token = 'uTnkYZ53xPCis20ZbkZ7Dgjw80bOx0wkXQgfYHmIZKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)