UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tds6CAl9dNI/D9TazSpYibvjiu/OyyUkyxWHohw29UI='
WHERE
key_id = '7dc844e0d1b7540b0c22d1bf6a5c82e673d55b05e77cb54c1cc081013bac7710'
AND (
token = 'tds6CAl9dNI/D9TazSpYibvjiu/OyyUkyxWHohw29UI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)